SELECT <exp> CASE <exp1> // multiple CASEs can occur <statements1> [ DEFAULT <statements> ] ENDSELECT [ <list> ]
CASE <a>,<b>; <statements>
CASE <a> TO <b>; <statements>
SELECT age CASE 0 TO 17 PrintF('Young\n') CASE 18 TO 50 PrintF('Adult\n') CASE 51 TO 120 PrintF('Old\n') DEFAULT PrintF('What???\n') ENDSELECT name:=SELECT Person.ID CASE 1 IS 'Paul' CASE 2 IS 'Jenny' CASE 3 IS 'Peter' CASE 4 IS 'Mark' ENDSELECT 'unknown'